[oracle@DC04024 ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 25-MAR-2014 16:38:58 Copyright (c) 1991, 2009, Oracle.  All rights reserved. Starting /XXXX/app/oracle/product/11.2.0/XXXX/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /XXXX/app/oracle/product/11.2.0/XXXX/network/admin/listener.ora Log messages written to /XXXX/app/oracle/diag/tnslsnr/DC04024/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DC04024)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias                     LISTENER Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date                25-MAR-2014 16:38:58 Uptime                    0 days 0 hr. 0 min. 0 sec Trace Level               off Security                  ON: Local OS Authentication SNMP                      OFF Listener Parameter File   /XXXX/app/oracle/product/11.2.0/XXXX/network/admin/listener.ora Listener Log File         /XXXX/app/oracle/diag/tnslsnr/DC04024/listener/alert/log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DC04024)(PORT=1521))) The listener supports no services The command completed successfully [oracle@DC04024 ~]$ 这样启动后远程连接会造成 oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor ******************************************* * 解决方案一 ******************************************* 原因：数据库实例不能注册到listener

--登录数据库 $sqlplus / as sysdba --显示服务名 SQL>show parameter service_names --强制注册服务 SQL>alter system register; --查看监听状态 $lsnrctl status ******************************************* * 解决方案二(静态注册) ******************************************* 在listener.ora里面添加了一行 SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =     (GLOBAL_DBNAME = globe)   (SID_NAME = globe)   ) ) ******************************************* * 解决方案三(静态注册) *******************************************

Oracle Net Manager修改配置

在下图的Listeners->Database Services中配置要监听的SID及ORACLE_HOME，退出保存。

*nux上面：

上一篇：Oracle 11g 超时问题的处理办法

下一篇：修改listener的inbound_connect_timeout参数的方法